StudentEnrollmentTermSummary 
EntityType  Independent 
Logical Entity Name  StudentEnrollmentTermSummary 
Default Table Name  AdEnrollTerm 
Logical Only  NO 
Owner  dbo 
Definition 
 
Note 
 

StudentEnrollmentTermSummary Attributes 
Attribute/Logical Rolename  Domain  Datatype  NULL  Definition 
TermId(FK)    INTEGER  YES 
 
Sequence    NUMERIC(4, 0)  NO 
 
BilledDate    DATETIME  YES 
 
TermGpa    NUMERIC(11, 6)  YES 
 
TermNumericAverage    NUMERIC(11, 6)  YES 
 
TermCreditHoursAttempted    NUMERIC(9, 2)  YES 
 
TermCreditHoursEarned    NUMERIC(9, 2)  YES 
 
TermClockHoursAttempted    NUMERIC(9, 2)  YES 
 
TermClockHoursEarned    NUMERIC(9, 2)  YES 
 
TermGpaPoints    NUMERIC(9, 2)  YES 
 
TermMinutesAttended    NUMERIC(11, 2)  YES 
 
TermMinutesAbsent    NUMERIC(9, 2)  YES 
 
CumulativeGpa    NUMERIC(11, 6)  YES 
 
CumulativeNumericAverage    NUMERIC(11, 6)  YES 
 
CumulativeCreditHoursAttempted    NUMERIC(9, 2)  YES 
 
CumulativeCreditHoursEarned    NUMERIC(9, 2)  YES 
 
CumulativeClockHoursAttempted    NUMERIC(9, 2)  YES 
 
CumulativeClockHoursEarned    NUMERIC(9, 2)  YES 
 
CumulativeGpaPoints    NUMERIC(9, 2)  YES 
 
CumulativeMinutesAttended    NUMERIC(11, 2)  YES 
 
CumulativeMinutesAbsent    NUMERIC(9, 2)  YES 
 
TermCreditHoursScheduled    NUMERIC(9, 2)  YES 
 
TermClockHoursScheduled    NUMERIC(9, 2)  YES 
 
Note    VARCHAR(255)  YES 
 
SAPStatus    CHAR(1)  YES 
 
EnrollmentStatusId(FK)    INTEGER  YES 
 
HonorsDescription    VARCHAR(50)  YES 
 
CreatedDateTime    DATETIME  NO 
 
LastModifiedDateTime    DATETIME  NO 
 
LastModifiedUserId    INTEGER  NO 
 
RowVersion    TIMESTAMP/DATE  NO 
 
HonorId(FK)    INTEGER  YES 
 
SapStatusId    INTEGER  YES 
 
StudentTermGpa    NUMERIC(11, 6)  YES 
 
StudentTermCreditHoursAttempted    NUMERIC(11, 2)  YES 
 
StudentTermClockHoursAttempted    NUMERIC(11, 2)  YES 
 
StudentTermGpaPoints    NUMERIC(11, 2)  YES 
 
StudentCumulativeGpa    NUMERIC(11, 6)  YES 
 
StudentCumulativeCreditHoursAttempted    NUMERIC(11, 2)  YES 
 
StudentCumulativeClockHoursAttempted    NUMERIC(11, 2)  YES 
 
StudentCumulativeGpaPoints    NUMERIC(11, 2)  YES 
 
StudentEnrollmentTermSummaryId(PK)    INTEGER  NO 
 
CumulativeGpaCredits    NUMERIC(9, 2)  YES 
 
TermMinutesMakeupAttended    INTEGER  YES 
 
CumulativeMinutesMakeupAttended    INTEGER  YES 
 
BgRndSetIdentifier    INTEGER  NO 
 
GradeLevelEvaluation    BIT  NO 
 
GradeLevelEvauationlDate    DATETIME  YES 
 
TermRegsteredCreditHours    NUMERIC(9, 2)  YES 
 
TermRegisteredClockHours    NUMERIC(9, 2)  YES 
 
StudentTermCreditHoursEarned    NUMERIC(9, 2)  YES 
 
StudentTermClockHoursEarned    NUMERIC(9, 2)  YES 
 
StudentCumulativeCreditHoursEarned    NUMERIC(9, 2)  YES 
 
StudentCumulativeClockHoursEarned    NUMERIC(9, 2)  YES 
 
TermAuditCreditHoursScheduled    NUMERIC(9, 2)  YES 
 
TermAssociatedGpaNumerator    MONEY(19, 4)  YES 
 
TermAssociatedGpaDenominator    MONEY(19, 4)  YES 
 
SAPCheckpoint    TINYINT  NO 
 
PartialSAPTerm    BIT  NO 
 
SapProcessType    CHAR(1)  NO 
 
StudentTermCreditHoursScheduled    NUMERIC(9, 2)  YES 
 
StudentTermAuditCreditHoursScheduled    NUMERIC(9, 2)  YES 
 
StudentTermClockHoursScheduled    NUMERIC(9, 2)  YES 
 
StudentTermRegisteredCreditHours    NUMERIC(9, 2)  YES 
 
StudentTermRegisteredClockHours    NUMERIC(9, 2)  YES 
 
StudentTermEnrollmentStatusId    INTEGER  YES 
 
TermGroupId    INTEGER  YES 
 
StudentId(FK)    INTEGER  YES 
 
StudentEnrollmentPeriodId(FK)    INTEGER  YES 
 

StudentEnrollmentTermSummary Keys 
Key Name  Key Type  Keys 
AdEnrollTerm_AdEnrollTermID_U_C_IDX  PrimaryKey  StudentEnrollmentTermSummaryId 
AdEnrollTerm_SyStudentID_N_N_IDX  Inversion Entry  Id_1 
AdEnrollTerm_AdTermID_AdAttStatId_AdEnrollId_AdEnrollTermID_U_N_IDX  Alternate Key  EnrollmentStatusId, Id_1 
AdEnrollTerm_AdEnrollID_Sequence_U_N_IDX  Unique Constraint  Id_1, Sequence 
AdEnrollTerm_AdEnrollTermID_GradeLevelEval_N_N_IDX  Inversion Entry  Id_1, GradeLevelEvaluation 
AdEnrollTerm_AdEnrollId_AdTermId_TermAuditCreditsSched_U_N_IDX  Alternate Key  Id_1, TermAuditCreditHoursScheduled 

StudentEnrollmentTermSummary Relationships 
Parent Relationships: 
Entity Name  Type  Cardinality  Business Name  VerbPhrase  InversePhrase  Foreign Keys  Is Supertype 
StudentEnrollmentPeriod  Non-Identifying  One To Zero or More        Id_1  NO 
Student  Non-Identifying  Zero or One to Zero or More        Id_1  NO 
Honor  Non-Identifying  Zero or One to Zero or More        HonorId  NO 
Student  Non-Identifying  Zero or One to Zero or More        StudentId  NO 
StudentEnrollmentPeriod  Non-Identifying  Zero or One to Zero or More        StudentEnrollmentPeriodId  NO 
EnrollmentStatus  Non-Identifying  Zero or One to Zero or More        EnrollmentStatusId  NO 
Term  Non-Identifying  Zero or One to Zero or More        TermId  NO 
EnrollmentStatus  Non-Identifying  Zero or One to Zero or More        EnrollmentStatusId  NO 
Child Relationships: 
Entity Name  Type  Cardinality  Business Name  VerbPhrase  InversePhrase  Foreign Keys  Is Subtype 
StudentEnrollmentTermRelationship  Identifying  One To Zero or More          NO 

StudentEnrollmentTermSummary Check Constraints 
Check Constraint Name  CheckConstraint 

StudentEnrollmentTermSummary Where Used - Model Usage 
Mapped Object  Is User Defined?  Denormalization Mappings  Description  Bound Attachments 
Logical
dbo.StudentEnrollmentTermSummary 
NO       
Physical (Microsoft SQL Server)
dbo.AdEnrollTerm 
NO       

StudentEnrollmentTermSummary Where Used - Submodel Usage 
Model  Submodel Usage 
Logical  Main Model 
Logical  CourseRegistration 
Logical  Grades/Attendance 
Logical  StudentEnrollment 
Physical (Microsoft SQL Server)  Main Model 
Physical (Microsoft SQL Server)  Academic Records 

StudentEnrollmentTermSummary Data Movement Rules 
Name  Type  Rule Text/Value